package com.example.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.dto.SelectDto;
import com.example.entity.vo.SfcTdVo;
import com.example.entity.yifei.SFCTD;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author : ssy
 * @date: 2023-12-20
 * @Description:
 */
public interface SFCTDMapper extends BaseMapper<SFCTD> {
    @DS("demo")
    @Insert("Insert into SFCTD(CREATOR,CREATE_DATE,TD001,TD002,TD003,TD005,TD004,UDF01,UDF02,UDF51)" +
            "values (#{CREATOR},#{CREATE_DATE},#{TD001},#{TD002},#{TD003},#{TD005}," +
            "#{TD004},#{UDF01},#{UDF02},#{UDF51})")
    void save(SFCTD saveSFCTD);

    List<SfcTdVo> querySfcTdIPage(SelectDto selectDto);

    @Delete("DELETE FROM SFCTD WHERE TD001 = #{td001} AND TD002 = #{td002}")
    Integer deleteBySfcteListInteger(String td001,String td002);
}
